﻿using FarPoint.Win.Spread;
using FarPoint.Win.Spread.CellType;
using FarPoint.Win.Spread.Dialogs;
using Spread.Common.Features.Sample;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using static System.Windows.Forms.VisualStyles.VisualStyleElement;

namespace Spread.Worksheet.Features
{
    public partial class RichTextEdit : BaseSampleControl
    {
        public RichTextEdit()
        {
            InitializeComponent();
            _fpSpread.LegacyBehaviors = LegacyBehaviors.None;
            _fpSpread.Features.RichTextEdit = RichTextEditMode.On;
            _fpSpread.Features.RichText = true;
            using (var stream = new MemoryStream(Properties.Resources.RichTextDemo))
            {
                _fpSpread.OpenExcel(stream);
            }

            _fpSpread.Features.ExcelCompatibleKeyboardShortcuts = true;
            _fpSpread.EditModeOn += OnSpreadEditModeOn;
            _fpSpread.EditModeOff += _fpSpread_EditModeOff;
        }

        private void _fpSpread_EditModeOff(object sender, EventArgs e)
        {
            _fpSpread.EditingControl.KeyDown -= OnEditingControlKeyDown;            
        }

        private void OnSpreadEditModeOn(object sender, EventArgs e)
        {
            if (_fpSpread.EditingControl != null)
                _fpSpread.EditingControl.KeyDown += OnEditingControlKeyDown;
        }

        private void OnEditingControlKeyDown(object sender, KeyEventArgs e)
        {
            if (e.Control && e.Shift && e.KeyCode == Keys.F)
            {
                if (_fpSpread.EditingControl is IRichTextEditor richTextEditor)
                {
                    BuiltInDialogs.FormatCells(richTextEditor);
                }
            }            
        }

    }
}

//
// RichTextEdit.Designer.cs
//

namespace Spread.Worksheet.Features
{
    partial class RichTextEdit
    {
        /// <summary> 
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary> 
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Component Designer generated code

        /// <summary> 
        /// Required method for Designer support - do not modify 
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this._fpSpread = new FarPoint.Win.Spread.FpSpread();
            this._fpSpread_Sheet1 = new FarPoint.Win.Spread.SheetView();
            this.pnlMain.SuspendLayout();
            ((System.ComponentModel.ISupportInitialize)(this._fpSpread)).BeginInit();
            ((System.ComponentModel.ISupportInitialize)(this._fpSpread_Sheet1)).BeginInit();
            this.SuspendLayout();
            // 
            // pnlMain
            // 
            this.pnlMain.Controls.Add(this._fpSpread);
            // 
            // _fpSpread
            // 
            this._fpSpread.AccessibleDescription = "";
            this._fpSpread.Dock = System.Windows.Forms.DockStyle.Fill;
            this._fpSpread.Location = new System.Drawing.Point(0, 0);
            this._fpSpread.Name = "_fpSpread";
            this._fpSpread.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
            this._fpSpread_Sheet1});
            this._fpSpread.Size = new System.Drawing.Size(477, 487);
            this._fpSpread.TabIndex = 1;
            // 
            // _fpSpread_Sheet1
            // 
            this._fpSpread_Sheet1.Reset();
            this._fpSpread_Sheet1.SheetName = "Sheet1";
            // Formulas and custom names must be loaded with R1C1 reference style
            this._fpSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
            this._fpSpread_Sheet1.ColumnFooter.DefaultStyle.BackColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.ColumnFooter.DefaultStyle.ForeColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.ColumnFooter.DefaultStyle.Locked = false;
            this._fpSpread_Sheet1.ColumnFooterSheetCornerStyle.BackColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.ColumnFooterSheetCornerStyle.ForeColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.ColumnFooterSheetCornerStyle.Locked = false;
            this._fpSpread_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.ColumnHeader.DefaultStyle.ForeColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.ColumnHeader.DefaultStyle.Locked = false;
            this._fpSpread_Sheet1.DefaultStyle.BackColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.DefaultStyle.ForeColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.DefaultStyle.Locked = false;
            this._fpSpread_Sheet1.FilterBar.DefaultStyle.BackColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.FilterBar.DefaultStyle.ForeColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.FilterBar.DefaultStyle.Locked = false;
            this._fpSpread_Sheet1.FilterBarHeaderStyle.BackColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.FilterBarHeaderStyle.ForeColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.FilterBarHeaderStyle.Locked = false;
            this._fpSpread_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.RowHeader.DefaultStyle.ForeColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.RowHeader.DefaultStyle.Locked = false;
            this._fpSpread_Sheet1.SheetCornerStyle.BackColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.SheetCornerStyle.ForeColor = System.Drawing.Color.Empty;
            this._fpSpread_Sheet1.SheetCornerStyle.Locked = false;
            this._fpSpread_Sheet1.SheetCornerStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center;
            this._fpSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
            // 
            // RichTextEdit
            // 
            this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
            this.Name = "RichTextEdit";
            this.pnlMain.ResumeLayout(false);
            ((System.ComponentModel.ISupportInitialize)(this._fpSpread)).EndInit();
            ((System.ComponentModel.ISupportInitialize)(this._fpSpread_Sheet1)).EndInit();
            this.ResumeLayout(false);

        }

        #endregion

        private FarPoint.Win.Spread.FpSpread _fpSpread;
        private FarPoint.Win.Spread.SheetView _fpSpread_Sheet1;
    }
}

